﻿CREATE TABLE [dbo].[ASMS_RechargeBill]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Number] nvarchar(64) NOT NULL,
	[BusinessId] uniqueidentifier,
	[StationId] uniqueidentifier,
	[CustomerId] uniqueidentifier NOT NULL,
	[RechargeItemId] uniqueidentifier,
	[RechargeItemTagData] nvarchar(64),
	[RechargeChannel] int NOT NULL,
	[Amount] money NOT NULL,
	[BoughtDate] datetime not null,
	[BoughtChannel] nvarchar(64) not null,
	[BoughtPrice] money not null,
	[SalesManagerId] uniqueidentifier,
    [SalesCommissionAmount] money not null,
	[PaidAmount] money,
    [PaidTime] DATETIME,
	[Cashier] nvarchar(64),
	[InvoiceType] nvarchar(64),
	[InvoiceNumber] nvarchar(64),
	[Memo] nvarchar(256),
	[CheckOutMemo] nvarchar(256),
	[Status] int NOT NULL,
	[CreatedTime] datetime NOT NULL,
	[Creator] nvarchar(64) NOT NULL
)
